
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class POIdemo {
    @Test
    public void test() throws IOException {

        XSSFWorkbook sheets = new XSSFWorkbook("C:\\Users\\huahua\\Desktop\\ordersetting_template.xlsx");
        XSSFSheet sheet = sheets.getSheetAt(0);
        int lastRowNum = sheet.getLastRowNum();


    }
}
